/*
 *  Copyright (C) 2010 Fabien Renaud
 * 
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 * 
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 * 
 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.boc.botv.dao.impl;

import com.boc.botv.common.Database;
import com.boc.botv.dao.TransactionDao;
import com.boc.botv.model.Transaction;
import java.util.Date;
import java.util.List;
import org.springframework.stereotype.Repository;
import java.sql.Timestamp;

/**
 *
 * @author Fabien Renaud
 */
@Repository("transactionDao")
public class TransactionDaoImpl implements TransactionDao {

  public List<Transaction> getTransactions() {
    return (List<Transaction>) Database.getSession().createQuery("from Transaction").list();
  }

  public List<Transaction> getTransactionsUser(int userId) {
    return (List<Transaction>) Database.getSession().createQuery("from Transaction as t where t.user=" + userId).list();
  }

  public List<Transaction> getTransactionsSite(int siteId) {
    return (List<Transaction>) Database.getSession().createQuery("from Transaction as t where t.siteAccount = " + siteId).list();
  }

  public List<Transaction> getTransactionsBetween(Date firstDate, Date lastDate) {
    Timestamp t1 = new Timestamp(firstDate.getTime());
    Timestamp t2 = new Timestamp(lastDate.getTime());
    return (List<Transaction>) Database.getSession().createQuery("from Transaction as t where t.dateOfOperation between '" + t1 + "' and '" + t2 + "'").list();
  }

  public void saveTransaction(Transaction transaction) {
    Database.getSession().save(transaction);
  }

  public void deleteTransaction(Transaction transaction) {
    Database.getSession().delete(transaction);
  }

  public Transaction getTransaction(int transactionId) {
    return (Transaction) Database.getSession().load(Transaction.class, transactionId);
  }
}
